TG: oracle_dbd/922

Forwarded from Pavel V

Таблица customer_surveys содержит 2 млн строк.
Колонки:
a) age_group (группы по возрасту: 10-19, 20-29, ..., 60+); b) income_level (5 категорий); c) country_code (около 200 стран), survey_text (CLOB). Данные не обновляются. Какой индекс будет эффективен?

Anonymous Quiz

B-tree по income_level и country_code

Bitmap по income_level, country_code и age_group

Bitmap только по survey_text

Индекс не нужен, хватит full scan

187 answered

www.tg-me.com/br/Oracle Developer‍/com.oracle_dbd/922

1.2K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/922

Create: 2025-05-26
Last Update: 2025-07-01 19:34:09

BY Oracle Developer👨🏻‍💻

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/oracle_dbd/922

Oracle Developer‍ Telegram | DID YOU KNOW?

Telegram Gives Up On Crypto Blockchain Project

Durov said on his Telegram channel today that the two and a half year blockchain and crypto project has been put to sleep. Ironically, after leaving Russia because the government wanted his encryption keys to his social media firm, Durov’s cryptocurrency idea lost steam because of a U.S. court. “The technology we created allowed for an open, free, decentralized exchange of value and ideas. TON had the potential to revolutionize how people store and transfer funds and information,” he wrote on his channel. “Unfortunately, a U.S. court stopped TON from happening.”